﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using WineDAL;

namespace WineBLL
{
    public class MessageBLL
    {
        MessageDAL helper = new MessageDAL();
        public string GetTable(string sql)
        {
            return helper.GetTable(sql);
        }
        public int ExcNonquery(string sql)
        {
            return helper.ExcNonquery(sql);
        }
        #region 管理员表
        /// <summary>
        /// 显示管理员表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetAdmins(string str)
        {
            return helper.GetAdmins(str);
        }
        /// <summary>
        /// 搜索管理员表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectAdmins(string str)
        {
            return helper.SelectAdmins(str);
        }
        /// <summary>
        /// 根据编号获取管理员表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidAdmins(string str)
        {
            return helper.GetidAdmins(str);
        }
        /// <summary>
        /// 修改管理员信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateAdmins(string str)
        {
            return helper.UpdateAdmins(str);
        }
        /// <summary>
        /// 添加管理员信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddAdmins(string str)
        {
            return helper.AddAdmins(str);
        }
        /// <summary>
        /// 删除管理员信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteAdmins(string str)
        {
            return helper.DeleteAdmins(str);
        }
        #endregion

        #region 管理员角色权限
        /// <summary>
        /// 显示管理员角色权限
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetAdminsPower(string str)
        {
            return helper.GetAdminsPower(str);
        }
        /// <summary>
        /// 搜索管理员角色权限
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectAdminsPower(string str)
        {
            return helper.SelectAdminsPower(str);
        }

        /// <summary>
        /// 根据编号获取管理员角色权限ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidAdminsPower(string str)
        {
            return helper.GetidAdminsPower(str);
        }
        /// <summary>
        /// 修改管理员角色权限
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateAdminsPower(string str)
        {
            return helper.UpdateAdminsPower(str);
        }
        /// <summary>
        /// 添加管理员角色权限
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddAdminsPower(string str)
        {
            return helper.AddAdminsPower(str);
        }
        /// <summary>
        /// 删除管理员角色权限
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteAdminsPower(string str)
        {
            return helper.DeleteAdminsPower(str);
        }
        #endregion

        #region 管理员角色表
        /// <summary>
        /// 管理员角色表显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetAdminRole(string str)
        {
            return helper.GetAdminRole(str);
        }
        /// <summary>
        /// 删除管理员角色
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteAdminRole(string str)
        {
            return helper.DeleteAdminRole(str);
        }
        /// <summary>
        /// 添加管理员角色
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddAdminRole(string str)
        {
            return helper.AddAdminRole(str);
        }
        /// <summary>
        /// 搜索管理员角色
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectAdminRole(string str)
        {
            return helper.SelectAdminRole(str);
        }
        /// <summary>
        /// 根据编号获取管理员角色
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidAdminRole(string str)
        {
            return helper.GetidAdminRole(str);
        }
        /// <summary>
        /// 修改管理员角色信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateAdminRole(string str)
        {
            return helper.UpdateAdminRole(str);
        }
        #endregion

        #region 地区信息
        /// <summary>
        /// 地区信息显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetArea(string str)
        {
            return helper.GetArea(str);
        }
        /// <summary>
        /// 搜索地区信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectArea(string str)
        {
            return helper.SelectArea(str);
        }
        /// <summary>
        /// 根据编号获取地区表的ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidArea(string str)
        {
            return helper.GetidArea(str);
        }
        /// <summary>
        /// 修改地区信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateArea(string str)
        {
            return helper.UpdateArea(str);
        }
        /// <summary>
        ///添加地区信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddArea(string str)
        {
            return helper.AddArea(str);
        }
        /// <summary>
        /// 删除地区信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteArea(string str)
        {
            return helper.DeleteArea(str);
        }
        #endregion

        #region 收藏表
        /// <summary>
        /// 显示收藏表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetCikkect(string str)
        {
            return helper.GetCikkect(str);
        }
        /// <summary>
        /// 搜索收藏表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectCikkect(string str)
        {
            return helper.SelectCikkect(str);
        }
        /// <summary>
        /// 根据编号获取收藏表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidCikkect(string str)
        {
            return helper.GetidCikkect(str);
        }
        /// <summary>
        /// 修改收藏表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateCikkect(string str)
        {
            return helper.UpdateCikkect(str);
        }
        /// <summary>
        /// 添加收藏表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddCikkect(string str)
        {
            return helper.AddCikkect(str);
        }
        /// <summary>
        /// 删除收藏表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteCikkect(string str)
        {
            return helper.DeleteCikkect(str);
        }
        #endregion

        #region 评论表
        /// <summary>
        /// 显示评论表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetComment(string str)
        {
            return helper.GetComment(str);
        }
        /// <summary>
        /// 搜索评论表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectComment(string str)
        {
            return helper.SelectComment(str);
        }
        /// <summary>
        /// 根据编号获取评论表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidComment(string str)
        {
            return helper.GetidComment(str);
        }
        /// <summary>
        /// 修改评论表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateComment(string str)
        {
            return helper.UpdateComment(str);
        }
        /// <summary>
        /// 添加评论表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddComment(string str)
        {
            return helper.AddComment(str);
        }
        /// <summary>
        /// 删除评论表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteComment(string str)
        {
            return helper.DeleteComment(str);
        }

        #endregion

        #region 用户收货信息
        /// <summary>
        /// 用户收货信息显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetConsignee(string str)
        {
            return helper.GetConsignee(str);
        }
        /// <summary>
        /// 搜索用户收货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectConsignee(string str)
        {
            return helper.SelectConsignee(str);
        }
        /// <summary>
        /// 根据编号获取用户收货信息ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidConsignee(string str)
        {
            return helper.GetidConsignee(str);
        }
        /// <summary>
        /// 修改用户收货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateConsignee(string str)
        {
            return helper.UpdateConsignee(str);
        }
        /// <summary>
        /// 添加用户收货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddConsignee(string str)
        {
            return helper.AddConsignee(str);
        }
        /// <summary>
        /// 删除用户收货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteConsignee(string str)
        {
            return helper.DeleteConsignee(str);
        }
        #endregion

        #region 商品信息表
        /// <summary>
        /// 显示商品信息表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetGoodsMessage(string str)
        {
            return helper.GetGoodsMessage(str);
        }
        /// <summary>
        /// 搜索管理员商品信息表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectGoodsMessage(string str)
        {
            return helper.SelectGoodsMessage(str);
        }
        /// <summary>
        /// 根据编号获取商品信息表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidGoodsMessage(string str)
        {
            return helper.GetidGoodsMessage(str);
        }
        /// <summary>
        /// 修改商品信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateGoodsMessage(string str)
        {
            return helper.UpdateGoodsMessage(str);
        }
        /// <summary>
        /// 添加商品信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddGoodsMessage(string str)
        {
            return helper.AddGoodsMessage(str);
        }
        /// <summary>
        /// 删除商品信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteGoodsMessage(string str)
        {
            return helper.DeleteGoodsMessage(str);
        }

        #endregion

        #region 商品类别表
        /// <summary>
        /// 显示商品类别表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetGoodsType(string str)
        {
            return helper.GetGoodsType(str);
        }
        /// <summary>
        /// 搜索管理员商品类别表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectGoodsType(string str)
        {
            return helper.SelectGoodsType(str);
        }
        /// <summary>
        /// 根据编号获取商品类别表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidGoodsType(string str)
        {
            return helper.GetidGoodsType(str);
        }
        /// <summary>
        /// 修改商品类别信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateGoodsType(string str)
        {
            return helper.UpdateGoodsType(str);
        }
        /// <summary>
        /// 添加商品类别信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddGoodsType(string str)
        {
            return helper.AddGoodsType(str);
        }
        /// <summary>
        /// 删除商品类别信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteGoodsType(string str)
        {
            return helper.DeleteGoodsType(str);
        }
        #endregion

        #region 订单从表
        /// <summary>
        /// 显示订单从表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetInd(string str)
        {
            return helper.GetInd(str);
        }
        /// <summary>
        /// 搜索订单从表信息 
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectInd(string str)
        {
            return helper.SelectInd(str);
        }
        /// <summary>
        /// 根据编号获取订单从表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidInd(string str)
        {
            return helper.GetidInd(str);
        }
        /// <summary>
        /// 修改订单从表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateInd(string str)
        {
            return helper.UpdateInd(str);
        }
        /// <summary>
        /// 添加订单从表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddInd(string str)
        {
            return helper.AddInd(str);
        }
        /// <summary>
        /// 删除订单从表信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteInd(string str)
        {
            return helper.DeleteInd(str);
        }
        #endregion

        #region 订单信息
        /// <summary>
        /// 显示订单信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetIndent(string str)
        {
            return helper.GetIndent(str);
        }
        /// <summary>
        /// 搜索订单信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectIndent(string str)
        {
            return helper.SelectIndent(str);
        }
        /// <summary>
        /// 根据编号获取订单信息ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidIndent(string str)
        {
            return helper.GetidIndent(str);
        }
        /// <summary>
        /// 修改订单信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateIndent(string str)
        {
            return helper.UpdateIndent(str);
        }
        /// <summary>
        /// 添加订单信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddIndent(string str)
        {
            return helper.AddIndent(str);
        }
        /// <summary>
        /// 删除订单信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteIndent(string str)
        {
            return helper.DeleteIndent(str);
        }
        #endregion

        #region 公告表
        /// <summary>
        /// 公告表显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetNotice(string str)
        {
            return helper.GetNotice(str);
        }
        /// <summary>
        /// 搜索公告表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectNotice(string str)
        {
            return helper.SelectNotice(str);
        }
        /// <summary>
        /// 根据编号获取公告表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidNotice(string str)
        {
            return helper.GetidNotice(str);
        }
        /// <summary>
        /// 修改公告表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateNotice(string str)
        {
            return helper.UpdateNotice(str);
        }
        /// <summary>
        /// 添加公告表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddNotice(string str)
        {
            return helper.AddNotice(str);
        }
        /// <summary>
        /// 删除公告表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteNotice(string str)
        {
            return helper.DeleteNotice(str);
        }
        #endregion

        #region 支付记录表
        /// <summary>
        /// 显示支付记录表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetRecord(string str)
        {
            return helper.GetRecord(str);
        }
        /// <summary>
        /// 搜索支付记录表
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectRecord(string str)
        {
            return helper.SelectRecord(str);
        }
        /// <summary>
        /// 根据编号获取支付记录表ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidRecord(string str)
        {
            return helper.GetidRecord(str);
        }
        /// <summary>
        /// 修改支付记录信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateRecord(string str)
        {
            return helper.UpdateRecord(str);
        }
        /// <summary>
        /// 添加支付记录信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddRecord(string str)
        {
            return helper.AddRecord(str);
        }
        /// <summary>
        /// 删除支付记录信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteRecord(string str)
        {
            return helper.DeleteRecord(str);
        }
        #endregion

        #region 商品退货信息
        /// <summary>
        /// 商品退货信息显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetRenturned(string str)
        {
            return helper.GetRenturned(str);
        }
        /// <summary>
        /// 搜索商品退货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectRenturned(string str)
        {
            return helper.SelectRenturned(str);
        }
        /// <summary>
        /// 根据编号获取商品退货信息ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidRenturned(string str)
        {
            return helper.GetidRenturned(str);
        }
        /// <summary>
        /// 修改商品退货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateRenturned(string str)
        {
            return helper.UpdateRenturned(str);
        }
        /// <summary>
        /// 添加商品退货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddRenturned(string str)
        {
            return helper.AddRenturned(str);
        }
        /// <summary>
        /// 删除商品退货信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteRenturned(string str)
        {
            return helper.DeleteRenturned(str);
        }
        #endregion

        #region 管理员角色权限关联表
        /// <summary>
        /// 管理员角色权限关联表显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetRolePower(string str)
        {
            return helper.GetRolePower(str);
        }
        /// <summary>
        /// 管理员角色权限关联表搜索
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectRolePower(string str)
        {
            return helper.SelectRolePower(str);
        }
        /// <summary>
        /// 管理员角色权限关联表获取编号
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidRolePower(string str)
        {
            return helper.GetidRolePower(str);
        }
        /// <summary>
        /// 添加管理员角色权限关联
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddRolePower(string str)
        {
            return helper.AddRolePower(str);
        }
        /// <summary>
        /// 删除管理员角色权限关联
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteRolePower(string str)
        {
            return helper.DeleteRolePower(str);
        }
        /// <summary>
        /// 修改管理员角色权限关联
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateRolePower(string str)
        {
            return helper.UpdateRolePower(str);
        }
        #endregion

        #region 购物车信息
        /// <summary>
        /// 购物车信息显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetShop(string str)
        {
            return helper.GetShop(str);
        }
        /// <summary>
        /// 搜索购物车信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectShop(string str)
        {
            return helper.SelectShop(str);
        }
        /// <summary>
        /// 根据编号获取购物车的ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidShop(string str)
        {
            return helper.GetidShop(str);
        }
        /// <summary>
        /// 修改购物车信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateShop(string str)
        {
            return helper.UpdateShop(str);
        }
        /// <summary>
        ///添加购物车信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddShop(string str)
        {
            return helper.AddShop(str);
        }
        /// <summary>
        /// 删除购物车信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DeleteShop(string str)
        {
            return helper.DeleteShop(str);
        }
        #endregion

        #region 用户信息
        /// <summary>
        /// 用户信息显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetUsers(string str)
        {
            return helper.GetUsers(str);
        }
        /// <summary>
        /// 搜索用户信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectUsers(string str)
        {
            return helper.SelectUsers(str);
        }
        /// <summary>
        /// 根据编号获取用户信息ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidUsers(string str)
        {
            return helper.GetidUsers(str);
        }
        /// <summary>
        /// 修改用户信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateUsers(string str)
        {
            return helper.UpdateUsers(str);
        }
        /// <summary>
        /// 添加用户信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddUsers(string str)
        {
            return helper.AddUsers(str);
        }
        /// <summary>
        /// 删除用户信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DelectUsers(string str)
        {
            return helper.DelectUsers(str);
        }
        #endregion

        #region 用户角色信息
        /// <summary>
        /// 用户角色信息显示
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetUsersRole(string str)
        {
            return helper.GetUsersRole(str);
        }
        /// <summary>
        /// 搜索用户角色信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string SelectUsersRole(string str)
        {
            return helper.SelectUsersRole(str);
        }
        /// <summary>
        /// 根据编号获取用户角色信息ID
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public string GetidUsersRole(string str)
        {
            return helper.GetidUsersRole(str);
        }
        /// <summary>
        /// 修改用户角色信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int UpdateUsersRole(string str)
        {
            return helper.UpdateUsersRole(str);
        }
        /// <summary>
        /// 添加用户角色信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int AddUsersRole(string str)
        {
            return helper.AddUsersRole(str);
        }
        /// <summary>
        /// 删除用户角色信息
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public int DelectUsersRole(string str)
        {
            return helper.DelectUsersRole(str);
        }
        #endregion
    }
}
